Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	67762
Missing cells	8
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.2 MiB
Average record size in memory	112.0 B

Variable types

Numeric	11
Categorical	3

Alerts

`date` has a high cardinality: 105 distinct values	High cardinality
`time` has a high cardinality: 40788 distinct values	High cardinality
`price` is highly correlated with `geo_lon` and 3 other fields	High correlation
`geo_lon` is highly correlated with `price` and 1 other fields	High correlation
`region` is highly correlated with `price` and 1 other fields	High correlation
`level` is highly correlated with `levels`	High correlation
`levels` is highly correlated with `level`	High correlation
`rooms` is highly correlated with `area`	High correlation
`area` is highly correlated with `price` and 2 other fields	High correlation
`kitchen_area` is highly correlated with `price` and 1 other fields	High correlation
`geo_lon` is highly correlated with `region`	High correlation
`region` is highly correlated with `geo_lon`	High correlation
`level` is highly correlated with `levels`	High correlation
`levels` is highly correlated with `level`	High correlation
`rooms` is highly correlated with `area`	High correlation
`area` is highly correlated with `rooms` and 1 other fields	High correlation
`kitchen_area` is highly correlated with `area`	High correlation
`geo_lon` is highly correlated with `region`	High correlation
`region` is highly correlated with `geo_lon`	High correlation
`rooms` is highly correlated with `area`	High correlation
`area` is highly correlated with `rooms`	High correlation
`Unnamed: 0` is highly correlated with `geo_lat` and 2 other fields	High correlation
`geo_lat` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`geo_lon` is highly correlated with `geo_lat` and 1 other fields	High correlation
`region` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`building_type` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`level` is highly correlated with `levels`	High correlation
`levels` is highly correlated with `building_type` and 1 other fields	High correlation
`price` is highly skewed (γ1 = 66.27105033)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`time` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`building_type` has 10025 (14.8%) zeros	Zeros

Reproduction

Analysis started	2022-02-18 15:54:19.880164
Analysis finished	2022-02-18 15:55:05.018653
Duration	45.14 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	67762
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42357.06037

Minimum	0
Maximum	84702
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	0
5-th percentile	4233.05
Q1	21096.25
median	42396.5
Q3	63561.75
95-th percentile	80474.95
Maximum	84702
Range	84702
Interquartile range (IQR)	42465.5

Descriptive statistics

Standard deviation	24476.83556
Coefficient of variation (CV)	0.5778690813
Kurtosis	-1.203344286
Mean	42357.06037
Median Absolute Deviation (MAD)	21227.5
Skewness	-0.0014222962
Sum	2870199125
Variance	599115479.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14040	1	< 0.1%
75449	1	< 0.1%
22770	1	< 0.1%
29558	1	< 0.1%
64279	1	< 0.1%
77172	1	< 0.1%
51240	1	< 0.1%
19880	1	< 0.1%
64086	1	< 0.1%
52885	1	< 0.1%
Other values (67752)	67752	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
84702	1	< 0.1%
84701	1	< 0.1%
84700	1	< 0.1%
84699	1	< 0.1%
84698	1	< 0.1%
84697	1	< 0.1%
84695	1	< 0.1%
84694	1	< 0.1%
84692	1	< 0.1%
84691	1	< 0.1%

price
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	13314
Distinct (%)	19.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4545642.519

Minimum	800
Maximum	1680000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	800
5-th percentile	1070000
Q1	1800000
median	2815000
Q3	4910849
95-th percentile	11207901.2
Maximum	1680000000
Range	1679999200
Interquartile range (IQR)	3110849

Descriptive statistics

Standard deviation	17313994.15
Coefficient of variation (CV)	3.808921197
Kurtosis	5186.635777
Mean	4545642.519
Median Absolute Deviation (MAD)	1265000
Skewness	66.27105033
Sum	3.080218284 × 10¹¹
Variance	2.997743933 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2500000	785	1.2%
1700000	784	1.2%
2200000	733	1.1%
1750000	724	1.1%
1850000	714	1.1%
1500000	710	1.0%
1800000	706	1.0%
2100000	705	1.0%
1650000	695	1.0%
2600000	681	1.0%
Other values (13304)	60525	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
800	1	< 0.1%
1000	1	< 0.1%
1300	1	< 0.1%
1650	1	< 0.1%
1750	1	< 0.1%
80000	1	< 0.1%
85000	1	< 0.1%
100000	3	< 0.1%
100100	1	< 0.1%
111111	1	< 0.1%

Value	Count	Frequency (%)
1680000000	1	< 0.1%
1451892000	4	< 0.1%
1003425000	6	< 0.1%
600000000	1	< 0.1%
375000000	1	< 0.1%
360044740	1	< 0.1%
330000000	1	< 0.1%
250000000	1	< 0.1%
230205652	1	< 0.1%
229453913	1	< 0.1%

date
Categorical

HIGH CARDINALITY

Distinct	105
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	529.5 KiB

2018-09-18	13913
2018-09-10	6893
2018-09-17	6772
2018-09-13	6588
2018-09-14	6306
Other values (100)	27290

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	677620
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	45 ?
Unique (%)	0.1%

Sample

1st row	2018-09-10
2nd row	2018-09-11
3rd row	2018-09-18
4th row	2018-09-12
5th row	2018-09-18

Common Values

Value	Count	Frequency (%)
2018-09-18	13913	20.5%
2018-09-10	6893	10.2%
2018-09-17	6772	10.0%
2018-09-13	6588	9.7%
2018-09-14	6306	9.3%
2018-09-11	5984	8.8%
2018-09-12	5182	7.6%
2018-09-15	4501	6.6%
2018-09-09	3899	5.8%
2018-09-16	3896	5.7%
Other values (95)	3828	5.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-09-18	13913	20.5%
2018-09-10	6893	10.2%
2018-09-17	6772	10.0%
2018-09-13	6588	9.7%
2018-09-14	6306	9.3%
2018-09-11	5984	8.8%
2018-09-12	5182	7.6%
2018-09-15	4501	6.6%
2018-09-09	3899	5.8%
2018-09-16	3896	5.7%
Other values (95)	3828	5.6%

Most occurring characters

Value	Count	Frequency (%)
0	150045	22.1%
-	135524	20.0%
1	133849	19.8%
8	85400	12.6%
2	73014	10.8%
9	71507	10.6%
7	6815	1.0%
3	6652	1.0%
4	6348	0.9%
5	4531	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	542096	80.0%
Dash Punctuation	135524	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	150045	27.7%
1	133849	24.7%
8	85400	15.8%
2	73014	13.5%
9	71507	13.2%
7	6815	1.3%
3	6652	1.2%
4	6348	1.2%
5	4531	0.8%
6	3935	0.7%

Dash Punctuation

Value	Count	Frequency (%)
-	135524	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	677620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	150045	22.1%
-	135524	20.0%
1	133849	19.8%
8	85400	12.6%
2	73014	10.8%
9	71507	10.6%
7	6815	1.0%
3	6652	1.0%
4	6348	0.9%
5	4531	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	677620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	150045	22.1%
-	135524	20.0%
1	133849	19.8%
8	85400	12.6%
2	73014	10.8%
9	71507	10.6%
7	6815	1.0%
3	6652	1.0%
4	6348	0.9%
5	4531	0.7%

time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	40788
Distinct (%)	60.2%
Missing	0
Missing (%)	0.0%
Memory size	529.5 KiB

15:05:51	15
15:05:47	13
12:16:42	13
02:38:22	11
00:26:42	11
Other values (40783)	67699

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	542096
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24155 ?
Unique (%)	35.6%

Sample

1st row	12:40:14
2nd row	17:26:15
3rd row	02:35:04
4th row	21:40:17
5th row	06:18:38

Common Values

Value	Count	Frequency (%)
15:05:51	15	< 0.1%
15:05:47	13	< 0.1%
12:16:42	13	< 0.1%
02:38:22	11	< 0.1%
00:26:42	11	< 0.1%
12:16:44	11	< 0.1%
02:38:48	10	< 0.1%
06:34:41	10	< 0.1%
15:09:49	10	< 0.1%
00:27:06	10	< 0.1%
Other values (40778)	67648	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
15:05:51	15	< 0.1%
12:16:42	13	< 0.1%
15:05:47	13	< 0.1%
02:38:22	11	< 0.1%
00:26:42	11	< 0.1%
12:16:44	11	< 0.1%
00:27:00	10	< 0.1%
18:39:30	10	< 0.1%
14:10:04	10	< 0.1%
00:26:58	10	< 0.1%
Other values (40778)	67648	99.8%

Most occurring characters

Value	Count	Frequency (%)
:	135524	25.0%
0	79929	14.7%
1	70337	13.0%
2	51119	9.4%
5	43503	8.0%
3	43121	8.0%
4	42778	7.9%
6	21379	3.9%
8	18269	3.4%
9	18190	3.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	406572	75.0%
Other Punctuation	135524	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	79929	19.7%
1	70337	17.3%
2	51119	12.6%
5	43503	10.7%
3	43121	10.6%
4	42778	10.5%
6	21379	5.3%
8	18269	4.5%
9	18190	4.5%
7	17947	4.4%

Other Punctuation

Value	Count	Frequency (%)
:	135524	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	542096	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	135524	25.0%
0	79929	14.7%
1	70337	13.0%
2	51119	9.4%
5	43503	8.0%
3	43121	8.0%
4	42778	7.9%
6	21379	3.9%
8	18269	3.4%
9	18190	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	542096	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	135524	25.0%
0	79929	14.7%
1	70337	13.0%
2	51119	9.4%
5	43503	8.0%
3	43121	8.0%
4	42778	7.9%
6	21379	3.9%
8	18269	3.4%
9	18190	3.4%

geo_lat
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30984
Distinct (%)	45.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.33473326

Minimum	41.459089
Maximum	69.404746
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	41.459089
5-th percentile	44.7338406
Q1	53.82923665
median	55.4367215
Q3	57.10704175
95-th percentile	59.99494287
Maximum	69.404746
Range	27.945657
Interquartile range (IQR)	3.2778051

Descriptive statistics

Standard deviation	5.094782394
Coefficient of variation (CV)	0.09376658517
Kurtosis	-0.2426889171
Mean	54.33473326
Median Absolute Deviation (MAD)	1.63131915
Skewness	-0.8819143949
Sum	3681830.195
Variance	25.95680764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55.0303931	1529	2.3%
59.904302	925	1.4%
59.91383	917	1.4%
59.882717	799	1.2%
59.994211	577	0.9%
60.012588	474	0.7%
59.885205	447	0.7%
59.84979	433	0.6%
55.013916	382	0.6%
54.9471407	374	0.6%
Other values (30974)	60905	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.459089	2	< 0.1%
41.875094	1	< 0.1%
42.0373088	1	< 0.1%
42.0385187	1	< 0.1%
42.0466759	1	< 0.1%
42.0466962	1	< 0.1%
42.056685	1	< 0.1%
42.058966	2	< 0.1%
42.0591726	1	< 0.1%
42.064618	1	< 0.1%

Value	Count	Frequency (%)
69.404746	1	< 0.1%
69.4020481	1	< 0.1%
69.36236	1	< 0.1%
69.3602242	1	< 0.1%
69.355203	1	< 0.1%
69.3489978	1	< 0.1%
69.3467308	1	< 0.1%
69.345469	1	< 0.1%
69.341612	1	< 0.1%
67.6050471	1	< 0.1%

geo_lon
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	30999
Distinct (%)	45.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.30529789

Minimum	27.6543701
Maximum	129.8489149
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	27.6543701
5-th percentile	30.274878
Q1	37.50769892
median	39.71583
Q3	60.74191022
95-th percentile	83.0232456
Maximum	129.8489149
Range	102.1945448
Interquartile range (IQR)	23.2342113

Descriptive statistics

Standard deviation	20.30577929
Coefficient of variation (CV)	0.4036509103
Kurtosis	-0.148124825
Mean	50.30529789
Median Absolute Deviation (MAD)	9.33973365
Skewness	1.012094497
Sum	3408787.596
Variance	412.3246725
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
83.0155452	1529	2.3%
30.30993	917	1.4%
30.451298	799	1.2%
30.47213	718	1.1%
30.274878	577	0.9%
30.378822	474	0.7%
30.370414	447	0.7%
30.218527	433	0.6%
83.00329	384	0.6%
82.9585961	374	0.6%
Other values (30989)	61110	90.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
27.6543701	1	< 0.1%
27.966288	1	< 0.1%
28.0112085	1	< 0.1%
28.088172	1	< 0.1%
28.1963821	1	< 0.1%
28.2444966	1	< 0.1%
28.2519947	1	< 0.1%
28.2532375	1	< 0.1%
28.263577	1	< 0.1%
28.263954	1	< 0.1%

Value	Count	Frequency (%)
129.8489149	1	< 0.1%
129.841386	1	< 0.1%
129.83985	1	< 0.1%
129.8375295	1	< 0.1%
129.787272	1	< 0.1%
129.7791793	1	< 0.1%
129.759397	1	< 0.1%
129.75934	2	< 0.1%
129.757996	1	< 0.1%
129.752714	1	< 0.1%

region
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	47
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	4035.560293

Minimum	3
Maximum	13919
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	2661
median	2843
Q3	5368
95-th percentile	9654
Maximum	13919
Range	13916
Interquartile range (IQR)	2707

Descriptive statistics

Standard deviation	3187.438598
Coefficient of variation (CV)	0.7898379324
Kurtosis	-0.4224183679
Mean	4035.560293
Median Absolute Deviation (MAD)	387
Skewness	0.8430140455
Sum	273453601
Variance	10159764.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
2661	12532	18.5%
9654	12105	17.9%
2843	9218	13.6%
81	6501	9.6%
3	3872	5.7%
3230	2816	4.2%
2922	2447	3.6%
6171	2109	3.1%
2722	1653	2.4%
5282	1577	2.3%
Other values (37)	12931	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	3872	5.7%
81	6501	9.6%
1010	900	1.3%
2072	309	0.5%
2359	262	0.4%
2594	25	< 0.1%
2604	1557	2.3%
2661	12532	18.5%
2722	1653	2.4%
2843	9218	13.6%

Value	Count	Frequency (%)
13919	129	0.2%
13913	9	< 0.1%
11991	69	0.1%
11416	68	0.1%
11171	139	0.2%
10160	313	0.5%
9654	12105	17.9%
9648	314	0.5%
9579	94	0.1%
8509	31	< 0.1%

building_type
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.756142914

Minimum	0
Maximum	5
Zeros	10025
Zeros (%)	14.8%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.15426488
Coefficient of variation (CV)	0.6572727485
Kurtosis	-0.9717106741
Mean	1.756142914
Median Absolute Deviation (MAD)	1
Skewness	0.1081529668
Sum	118998
Variance	1.332327413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	22229	32.8%
3	20653	30.5%
2	12490	18.4%
0	10025	14.8%
4	1990	2.9%
5	374	0.6%
(Missing)	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10025	14.8%
1	22229	32.8%
2	12490	18.4%
3	20653	30.5%
4	1990	2.9%
5	374	0.6%

Value	Count	Frequency (%)
5	374	0.6%
4	1990	2.9%
3	20653	30.5%
2	12490	18.4%
1	22229	32.8%
0	10025	14.8%

level
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	34
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6.270450554

Minimum	1
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	9
95-th percentile	16
Maximum	34
Range	33
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.903953124
Coefficient of variation (CV)	0.7820734861
Kurtosis	1.710576404
Mean	6.270450554
Median Absolute Deviation (MAD)	3
Skewness	1.333415385
Sum	424892
Variance	24.04875624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
2	8914	13.2%
1	7814	11.5%
3	7779	11.5%
4	6865	10.1%
5	6661	9.8%
6	4101	6.1%
7	3949	5.8%
8	3871	5.7%
9	3808	5.6%
10	2955	4.4%
Other values (24)	11044	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7814	11.5%
2	8914	13.2%
3	7779	11.5%
4	6865	10.1%
5	6661	9.8%
6	4101	6.1%
7	3949	5.8%
8	3871	5.7%
9	3808	5.6%
10	2955	4.4%

Value	Count	Frequency (%)
34	4	< 0.1%
33	2	< 0.1%
32	4	< 0.1%
31	6	< 0.1%
30	13	< 0.1%
29	4	< 0.1%
28	8	< 0.1%
27	19	< 0.1%
26	37	0.1%
25	138	0.2%

levels
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	39
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	11.51632945

Minimum	1
Maximum	39
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	5
median	10
Q3	16
95-th percentile	24
Maximum	39
Range	38
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.410053558
Coefficient of variation (CV)	0.5566056082
Kurtosis	-0.2606603837
Mean	11.51632945
Median Absolute Deviation (MAD)	5
Skewness	0.6969757658
Sum	780358
Variance	41.08878662
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
5	12092	17.8%
10	11772	17.4%
9	7985	11.8%
17	3692	5.4%
16	3660	5.4%
18	2433	3.6%
25	2272	3.4%
14	2223	3.3%
12	2106	3.1%
4	2030	3.0%
Other values (29)	17496	25.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	264	0.4%
2	1351	2.0%
3	1826	2.7%
4	2030	3.0%
5	12092	17.8%
6	1488	2.2%
7	928	1.4%
8	963	1.4%
9	7985	11.8%
10	11772	17.4%

Value	Count	Frequency (%)
39	2	< 0.1%
38	2	< 0.1%
37	9	< 0.1%
36	5	< 0.1%
35	9	< 0.1%
34	8	< 0.1%
33	134	0.2%
32	26	< 0.1%
31	27	< 0.1%
30	26	< 0.1%

rooms
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.801272118

Minimum	-2
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	798
Negative (%)	1.2%
Memory size	529.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	9
Range	11
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9262339033
Coefficient of variation (CV)	0.5142109812
Kurtosis	0.9952084724
Mean	1.801272118
Median Absolute Deviation (MAD)	1
Skewness	0.4860337747
Sum	122056
Variance	0.8579092436
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	29197	43.1%
2	22205	32.8%
3	13450	19.8%
4	1733	2.6%
-1	797	1.2%
5	334	0.5%
6	28	< 0.1%
8	6	< 0.1%
9	5	< 0.1%
7	5	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	1	< 0.1%
-1	797	1.2%
1	29197	43.1%
2	22205	32.8%
3	13450	19.8%
4	1733	2.6%
5	334	0.5%
6	28	< 0.1%
7	5	< 0.1%
8	6	< 0.1%

Value	Count	Frequency (%)
9	5	< 0.1%
8	6	< 0.1%
7	5	< 0.1%
6	28	< 0.1%
5	334	0.5%
4	1733	2.6%
3	13450	19.8%
2	22205	32.8%
1	29197	43.1%
-1	797	1.2%

area
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3655
Distinct (%)	5.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	55.02651363

Minimum	5
Maximum	942
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	5
5-th percentile	30
Q1	39
median	49
Q3	64
95-th percentile	97
Maximum	942
Range	937
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	26.35769425
Coefficient of variation (CV)	0.4789998949
Kurtosis	88.17493391
Mean	55.02651363
Median Absolute Deviation (MAD)	12
Skewness	5.314982078
Sum	3728651.59
Variance	694.728046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	1218	1.8%
40	1209	1.8%
43	1187	1.8%
45	1163	1.7%
42	1101	1.6%
60	1076	1.6%
33	968	1.4%
30	943	1.4%
38	928	1.4%
32	922	1.4%
Other values (3645)	57046	84.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	1	< 0.1%
5.6	3	< 0.1%
10	2	< 0.1%
10.5	1	< 0.1%
11	1	< 0.1%
11.5	1	< 0.1%
12	14	< 0.1%
13	12	< 0.1%
13.5	1	< 0.1%
13.6	2	< 0.1%

Value	Count	Frequency (%)
942	1	< 0.1%
825	1	< 0.1%
753	3	< 0.1%
700	1	< 0.1%
600	1	< 0.1%
590.7	1	< 0.1%
530	1	< 0.1%
526	1	< 0.1%
505	1	< 0.1%
487	1	< 0.1%

kitchen_area
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1724
Distinct (%)	2.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	11.06171544

Minimum	0.07
Maximum	187.17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	529.5 KiB

Quantile statistics

Minimum	0.07
5-th percentile	5
Q1	7
median	10
Q3	13
95-th percentile	20.66
Maximum	187.17
Range	187.1
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.9410838
Coefficient of variation (CV)	0.5370852136
Kurtosis	29.33962918
Mean	11.06171544
Median Absolute Deviation (MAD)	3
Skewness	3.270106848
Sum	749552.9
Variance	35.29647672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	6192	9.1%
9	5117	7.6%
10	4581	6.8%
8	3898	5.8%
12	3483	5.1%
7	3325	4.9%
5	3292	4.9%
11	2760	4.1%
14	1895	2.8%
13	1472	2.2%
Other values (1714)	31746	46.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.07	1	< 0.1%
0.1	8	< 0.1%
0.11	1	< 0.1%
0.12	1	< 0.1%
0.13	6	< 0.1%
0.2	1	< 0.1%
1	212	0.3%
2	237	0.3%
2.1	1	< 0.1%
2.2	5	< 0.1%

Value	Count	Frequency (%)
187.17	1	< 0.1%
100	1	< 0.1%
95	2	< 0.1%
88	1	< 0.1%
87	1	< 0.1%
85.5	1	< 0.1%
85	1	< 0.1%
79	1	< 0.1%
78	9	< 0.1%
76.8	1	< 0.1%

object_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	529.5 KiB

1.0	51624
11.0	16137

Length

Max length	4
Median length	3
Mean length	3.238145836
Min length	3

Characters and Unicode

Total characters	219420
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	51624	76.2%
11.0	16137	23.8%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	51624	76.2%
11.0	16137	23.8%

Most occurring characters

Value	Count	Frequency (%)
1	83898	38.2%
.	67761	30.9%
0	67761	30.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	151659	69.1%
Other Punctuation	67761	30.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	83898	55.3%
0	67761	44.7%

Other Punctuation

Value	Count	Frequency (%)
.	67761	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	219420	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	83898	38.2%
.	67761	30.9%
0	67761	30.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	219420	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	83898	38.2%
.	67761	30.9%
0	67761	30.9%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	price	date	time	geo_lat	geo_lon	region	building_type	level	levels	rooms	area	kitchen_area	object_type
0	14040	3900000	2018-09-10	12:40:14	55.786480	49.223459	2922.0	1.0	10.0	11.0	3.0	67.00	8.80	1.0
1	24608	4250000	2018-09-11	17:26:15	55.905045	37.393578	81.0	1.0	25.0	25.0	1.0	39.00	10.50	1.0
2	76636	4340360	2018-09-18	02:35:04	59.882717	30.451298	2661.0	0.0	4.0	27.0	1.0	57.11	11.38	1.0
3	31944	8000000	2018-09-12	21:40:17	55.640462	37.359415	3.0	1.0	1.0	17.0	3.0	74.50	10.00	1.0
4	82427	2750000	2018-09-18	06:18:38	55.042053	82.940926	9654.0	1.0	1.0	5.0	2.0	44.60	6.00	1.0
5	1543	2200000	2018-09-08	05:48:47	52.071278	113.395982	10160.0	1.0	1.0	5.0	3.0	69.00	10.00	1.0
6	16791	3300000	2018-09-10	17:11:38	59.945788	30.270863	2661.0	3.0	2.0	5.0	-1.0	27.00	2.00	1.0
7	62129	2300000	2018-09-17	10:32:03	47.230470	39.617520	3230.0	1.0	3.0	10.0	1.0	40.00	10.00	1.0
8	80828	1500000	2018-09-18	04:57:54	63.561706	53.672052	4417.0	3.0	4.0	4.0	1.0	31.00	6.00	1.0
9	52067	2599000	2018-09-15	14:54:03	56.314938	38.139990	81.0	3.0	1.0	5.0	2.0	45.00	5.00	1.0

Last rows

	Unnamed: 0	price	date	time	geo_lat	geo_lon	region	building_type	level	levels	rooms	area	kitchen_area	object_type
67752	872	1450000	2018-09-08	01:51:23	54.946948	82.970115	9654.0	1.0	7.0	10.0	1.0	48.94	14.00	11.0
67753	33022	1600000	2018-09-13	03:40:49	55.013248	83.000609	9654.0	1.0	1.0	10.0	1.0	48.94	13.78	11.0
67754	1921	3600000	2018-09-08	09:09:27	55.744787	37.999236	81.0	3.0	18.0	18.0	1.0	39.00	8.70	1.0
67755	66657	2800000	2018-09-17	20:42:21	45.040160	38.975965	2843.0	1.0	2.0	9.0	3.0	64.00	9.00	1.0
67756	3589	2250000	2018-09-08	15:22:17	56.797201	60.512647	6171.0	1.0	3.0	15.0	1.0	37.00	10.00	11.0
67757	53806	7900000	2018-09-15	23:27:54	59.980207	30.391762	2661.0	3.0	12.0	13.0	2.0	61.00	15.00	1.0
67758	39082	2950000	2018-09-13	16:53:47	55.500098	36.030344	81.0	3.0	4.0	5.0	2.0	44.00	6.00	1.0
67759	60575	1241000	2018-09-17	06:56:11	54.946046	82.961274	9654.0	1.0	15.0	18.0	1.0	41.39	11.00	11.0
67760	7787	1250000	2018-09-09	13:30:40	61.711546	30.700702	8090.0	3.0	1.0	5.0	1.0	33.00	7.60	1.0
67761	50467	6508800	2018-09-15	08:44:50	55.672380	37.855156	81.0	2.0	6.0	33.0	2.0	67.80	21.00	11.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows